Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	584314
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	80.2 MiB
Average record size in memory	144.0 B

Variable types

Numeric	7
Categorical	5
DateTime	3
Text	2

Alerts

`item_id` is highly overall correlated with `Customer ID` and 1 other fields	High correlation
`price` is highly overall correlated with `grand_total`	High correlation
`grand_total` is highly overall correlated with `price`	High correlation
`Customer ID` is highly overall correlated with `item_id` and 1 other fields	High correlation
`status` is highly overall correlated with `BI Status`	High correlation
`BI Status` is highly overall correlated with `status`	High correlation
`Year` is highly overall correlated with `item_id` and 1 other fields	High correlation
`status` is highly imbalanced (51.7%)	Imbalance
`qty_ordered` is highly skewed (γ1 = 185.8821021)	Skewed
`grand_total` is highly skewed (γ1 = 254.9541717)	Skewed
`item_id` has unique values	Unique
`grand_total` has 9616 (1.6%) zeros	Zeros
`discount_amount` has 376121 (64.4%) zeros	Zeros

Reproduction

Analysis started	2023-09-19 08:21:24.025894
Analysis finished	2023-09-19 08:23:03.421173
Duration	1 minute and 39.4 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

item_id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	584314
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	565590.35

Minimum	211131
Maximum	905208
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 MiB

Quantile statistics

Minimum	211131
5-th percentile	247513.65
Q1	394945.25
median	568301
Q3	738981.75
95-th percentile	872508.35
Maximum	905208
Range	694077
Interquartile range (IQR)	344036.5

Descriptive statistics

Standard deviation	200101.17
Coefficient of variation (CV)	0.35379171
Kurtosis	-1.184214
Mean	565590.35
Median Absolute Deviation (MAD)	171855.5
Skewness	-0.047040402
Sum	3.3048236 × 10¹¹
Variance	4.0040479 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
211131	1	< 0.1%
682904	1	< 0.1%
682902	1	< 0.1%
682889	1	< 0.1%
682890	1	< 0.1%
682892	1	< 0.1%
682894	1	< 0.1%
682896	1	< 0.1%
682905	1	< 0.1%
682900	1	< 0.1%
Other values (584304)	584304	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
211131	1	< 0.1%
211133	1	< 0.1%
211134	1	< 0.1%
211135	1	< 0.1%
211136	1	< 0.1%
211137	1	< 0.1%
211138	1	< 0.1%
211139	1	< 0.1%
211140	1	< 0.1%
211141	1	< 0.1%

Value	Count	Frequency (%)
905208	1	< 0.1%
905207	1	< 0.1%
905206	1	< 0.1%
905205	1	< 0.1%
905204	1	< 0.1%
905202	1	< 0.1%
905200	1	< 0.1%
905199	1	< 0.1%
905198	1	< 0.1%
905196	1	< 0.1%

status
Categorical

HIGH CORRELATION IMBALANCE

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

complete	233684
canceled	201127
received	77284
order_refunded	59498
refund	8020
Other values (11)	4701

Length

Max length	14
Median length	8
Mean length	8.549944
Min length	2

Characters and Unicode

Total characters	4995852
Distinct characters	24
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	complete
2nd row	canceled
3rd row	canceled
4th row	complete
5th row	order_refunded

Common Values

Value	Count	Frequency (%)
complete	233684	40.0%
canceled	201127	34.4%
received	77284	13.2%
order_refunded	59498	10.2%
refund	8020	1.4%
cod	2854	0.5%
paid	1159	0.2%
closed	494	0.1%
payment_review	57	< 0.1%
pending	48	< 0.1%
Other values (6)	89	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
complete	233684	40.0%
canceled	201127	34.4%
received	77284	13.2%
order_refunded	59498	10.2%
refund	8020	1.4%
cod	2854	0.5%
paid	1159	0.2%
closed	494	0.1%
payment_review	57	< 0.1%
pending	48	< 0.1%
Other values (6)	89	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	1288780	25.8%
c	716607	14.3%
d	469559	9.4%
l	435343	8.7%
o	296594	5.9%
n	268849	5.4%
r	263898	5.3%
p	235002	4.7%
m	233741	4.7%
t	233741	4.7%
Other values (14)	553738	11.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4936282	98.8%
Connector Punctuation	59562	1.2%
Other Punctuation	4	< 0.1%
Uppercase Letter	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1288780	26.1%
c	716607	14.5%
d	469559	9.5%
l	435343	8.8%
o	296594	6.0%
n	268849	5.4%
r	263898	5.3%
p	235002	4.8%
m	233741	4.7%
t	233741	4.7%
Other values (11)	494168	10.0%

Connector Punctuation

Value	Count	Frequency (%)
_	59562	100.0%

Other Punctuation

Value	Count	Frequency (%)
\	4	100.0%

Uppercase Letter

Value	Count	Frequency (%)
N	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4936286	98.8%
Common	59566	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1288780	26.1%
c	716607	14.5%
d	469559	9.5%
l	435343	8.8%
o	296594	6.0%
n	268849	5.4%
r	263898	5.3%
p	235002	4.8%
m	233741	4.7%
t	233741	4.7%
Other values (12)	494172	10.0%

Common

Value	Count	Frequency (%)
_	59562	> 99.9%
\	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4995852	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1288780	25.8%
c	716607	14.3%
d	469559	9.4%
l	435343	8.7%
o	296594	5.9%
n	268849	5.4%
r	263898	5.3%
p	235002	4.7%
m	233741	4.7%
t	233741	4.7%
Other values (14)	553738	11.1%

created_at
Date

Distinct	789
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

Minimum	2016-07-01 00:00:00
Maximum	2018-08-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

sku
Text

Distinct	84869
Distinct (%)	14.5%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

Length

Max length	69
Median length	63
Mean length	20.254076
Min length	5

Characters and Unicode

Total characters	11834740
Distinct characters	94
Distinct categories	13 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	38636 ?
Unique (%)	6.6%

Sample

1st row	kreations_YI 06-L
2nd row	kcc_Buy 2 Frey Air Freshener & Get 1 Kasual Body Spray Free
3rd row	Ego_UP0017-999-MR0
4th row	kcc_krone deal
5th row	BK7010400AG

Value	Count	Frequency (%)
	17805	1.9%
infinix	5978	0.7%
halwa	5418	0.6%
hot	4859	0.5%
black	4616	0.5%
one	4385	0.5%
of	4104	0.4%
matsam59db75adb2f80	3775	0.4%
sohan	3718	0.4%
al	3661	0.4%
Other values (86302)	856460	93.6%

Most occurring characters

Value	Count	Frequency (%)
A	765671	6.5%
5	536681	4.5%
0	464114	3.9%
B	423956	3.6%
-	366666	3.1%
e	348339	2.9%
9	347767	2.9%
1	345299	2.9%
a	344863	2.9%
E	340559	2.9%
Other values (84)	7550825	63.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4515531	38.2%
Decimal Number	3266333	27.6%
Lowercase Letter	3026234	25.6%
Dash Punctuation	366685	3.1%
Space Separator	336852	2.8%
Connector Punctuation	297722	2.5%
Other Punctuation	14679	0.1%
Open Punctuation	4520	< 0.1%
Close Punctuation	4506	< 0.1%
Math Symbol	1525	< 0.1%
Other values (3)	153	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	348339	11.5%
a	344863	11.4%
i	247921	8.2%
o	208073	6.9%
l	201562	6.7%
r	200688	6.6%
n	195456	6.5%
t	166925	5.5%
s	143907	4.8%
c	121305	4.0%
Other values (18)	847195	28.0%

Uppercase Letter

Value	Count	Frequency (%)
A	765671	17.0%
B	423956	9.4%
E	340559	7.5%
C	327375	7.2%
F	322824	7.1%
D	288831	6.4%
M	276375	6.1%
S	231828	5.1%
T	191223	4.2%
P	175894	3.9%
Other values (17)	1170995	25.9%

Decimal Number

Value	Count	Frequency (%)
5	536681	16.4%
0	464114	14.2%
9	347767	10.6%
1	345299	10.6%
2	281020	8.6%
3	274323	8.4%
7	271621	8.3%
4	262124	8.0%
6	242793	7.4%
8	240591	7.4%

Other Punctuation

Value	Count	Frequency (%)
&	5968	40.7%
.	3473	23.7%
/	1987	13.5%
'	1174	8.0%
,	922	6.3%
#	392	2.7%
"	280	1.9%
:	251	1.7%
%	231	1.6%
\	1	< 0.1%

Math Symbol

Value	Count	Frequency (%)
+	1502	98.5%
\|	12	0.8%
=	9	0.6%
×	2	0.1%

Control

Value	Count	Frequency (%)
	12	46.2%
	12	46.2%
	2	7.7%

Dash Punctuation

Value	Count	Frequency (%)
-	366666	> 99.9%
–	19	< 0.1%

Space Separator

Value	Count	Frequency (%)
	336309	99.8%
	543	0.2%

Open Punctuation

Value	Count	Frequency (%)
(	4495	99.4%
[	25	0.6%

Close Punctuation

Value	Count	Frequency (%)
)	4481	99.4%
]	25	0.6%

Other Symbol

Value	Count	Frequency (%)
°	3	75.0%
®	1	25.0%

Connector Punctuation

Value	Count	Frequency (%)
_	297722	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	123	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7541765	63.7%
Common	4292975	36.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	765671	10.2%
B	423956	5.6%
e	348339	4.6%
a	344863	4.6%
E	340559	4.5%
C	327375	4.3%
F	322824	4.3%
D	288831	3.8%
M	276375	3.7%
i	247921	3.3%
Other values (45)	3855051	51.1%

Common

Value	Count	Frequency (%)
5	536681	12.5%
0	464114	10.8%
-	366666	8.5%
9	347767	8.1%
1	345299	8.0%
	336309	7.8%
_	297722	6.9%
2	281020	6.5%
3	274323	6.4%
7	271621	6.3%
Other values (29)	771453	18.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11834127	> 99.9%
None	594	< 0.1%
Punctuation	19	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	765671	6.5%
5	536681	4.5%
0	464114	3.9%
B	423956	3.6%
-	366666	3.1%
e	348339	2.9%
9	347767	2.9%
1	345299	2.9%
a	344863	2.9%
E	340559	2.9%
Other values (76)	7550212	63.8%

None

Value	Count	Frequency (%)
	543	91.4%
è	20	3.4%
È	13	2.2%
é	12	2.0%
°	3	0.5%
×	2	0.3%
®	1	0.2%

Punctuation

Value	Count	Frequency (%)
–	19	100.0%

price
Real number (ℝ)

HIGH CORRELATION

Distinct	9119
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6350.7663

Minimum	0
Maximum	1012625.9
Zeros	2214
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	8.9 MiB

Quantile statistics

Minimum	0
5-th percentile	95
Q1	360
median	899.4
Q3	4090
95-th percentile	29199
Maximum	1012625.9
Range	1012625.9
Interquartile range (IQR)	3730

Descriptive statistics

Standard deviation	14951.495
Coefficient of variation (CV)	2.354282
Kurtosis	71.228003
Mean	6350.7663
Median Absolute Deviation (MAD)	699.4
Skewness	5.2278765
Sum	3.7108417 × 10⁹
Variance	2.235472 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000	11077	1.9%
999	10119	1.7%
500	9213	1.6%
699	8407	1.4%
499	7693	1.3%
399	6999	1.2%
299	6647	1.1%
799	6024	1.0%
599	6008	1.0%
899	4471	0.8%
Other values (9109)	507656	86.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2214	0.4%
0.1	15	< 0.1%
0.11	8	< 0.1%
0.15	1	< 0.1%
0.2	16	< 0.1%
0.8	9	< 0.1%
1	1237	0.2%
1.3	24	< 0.1%
1.5	20	< 0.1%
1.6	34	< 0.1%

Value	Count	Frequency (%)
1012625.9	1	< 0.1%
515975	1	< 0.1%
479000	4	< 0.1%
330499	2	< 0.1%
320000	1	< 0.1%
307970	2	< 0.1%
300000	4	< 0.1%
291667	2	< 0.1%
289999	1	< 0.1%
265499	1	< 0.1%

qty_ordered
Real number (ℝ)

SKEWED

Distinct	73
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2943075

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	3
Maximum	1000
Range	999
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.9881503
Coefficient of variation (CV)	3.0813004
Kurtosis	42941.241
Mean	1.2943075
Median Absolute Deviation (MAD)	0
Skewness	185.8821
Sum	756282
Variance	15.905343
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	505125	86.4%
2	46607	8.0%
3	15404	2.6%
5	11202	1.9%
4	4139	0.7%
6	588	0.1%
10	291	< 0.1%
8	153	< 0.1%
7	112	< 0.1%
12	95	< 0.1%
Other values (63)	598	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	505125	86.4%
2	46607	8.0%
3	15404	2.6%
4	4139	0.7%
5	11202	1.9%
6	588	0.1%
7	112	< 0.1%
8	153	< 0.1%
9	42	< 0.1%
10	291	< 0.1%

Value	Count	Frequency (%)
1000	6	< 0.1%
502	1	< 0.1%
500	4	< 0.1%
380	1	< 0.1%
304	1	< 0.1%
300	2	< 0.1%
200	7	< 0.1%
187	1	< 0.1%
186	1	< 0.1%
185	1	< 0.1%

grand_total
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	36828
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8532.8924

Minimum	-1594
Maximum	17888000
Zeros	9616
Zeros (%)	1.6%
Negative	76
Negative (%)	< 0.1%
Memory size	8.9 MiB

Quantile statistics

Minimum	-1594
5-th percentile	160
Q1	945.2
median	1961
Q3	6999
95-th percentile	34499
Maximum	17888000
Range	17889594
Interquartile range (IQR)	6053.8

Descriptive statistics

Standard deviation	61331.682
Coefficient of variation (CV)	7.1876779
Kurtosis	74165.691
Mean	8532.8924
Median Absolute Deviation (MAD)	1462
Skewness	254.95417
Sum	4.9858885 × 10⁹
Variance	3.7615752 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9616	1.6%
1000	5145	0.9%
2000	3780	0.6%
2500	3235	0.6%
5000	2912	0.5%
1149	2524	0.4%
12599	2520	0.4%
399	2459	0.4%
4000	2387	0.4%
150	2238	0.4%
Other values (36818)	547498	93.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1594	1	< 0.1%
-1311.5	7	< 0.1%
-1106.65	1	< 0.1%
-873.4	1	< 0.1%
-528	1	< 0.1%
-511	2	< 0.1%
-425.7	2	< 0.1%
-384	1	< 0.1%
-340.6	16	< 0.1%
-249	1	< 0.1%

Value	Count	Frequency (%)
17888000	6	< 0.1%
1315875	1	< 0.1%
1280473	2	< 0.1%
1279980	1	< 0.1%
1155966	1	< 0.1%
1039479	1	< 0.1%
1028751	4	< 0.1%
1012625.9	1	< 0.1%
888065	7	< 0.1%
847024	7	< 0.1%

category_name_1
Categorical

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

Mobiles & Tablets	115709
Men's Fashion	92218
Women's Fashion	59720
Appliances	52413
Superstore	43611
Other values (11)	220643

Length

Max length	18
Median length	17
Mean length	12.839496
Min length	2

Characters and Unicode

Total characters	7502297
Distinct characters	39
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Women's Fashion
2nd row	Beauty & Grooming
3rd row	Women's Fashion
4th row	Beauty & Grooming
5th row	Soghaat

Common Values

Value	Count	Frequency (%)
Mobiles & Tablets	115709	19.8%
Men's Fashion	92218	15.8%
Women's Fashion	59720	10.2%
Appliances	52413	9.0%
Superstore	43611	7.5%
Beauty & Grooming	41493	7.1%
Soghaat	34011	5.8%
Others	29208	5.0%
Home & Living	26504	4.5%
Entertainment	26322	4.5%
Other values (6)	63105	10.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	221175	18.8%
fashion	151938	12.9%
mobiles	115709	9.8%
tablets	115709	9.8%
men's	92218	7.8%
women's	59720	5.1%
appliances	52413	4.4%
superstore	43611	3.7%
beauty	41493	3.5%
grooming	41493	3.5%
Other values (14)	243123	20.6%

Most occurring characters

Value	Count	Frequency (%)
s	696387	9.3%
e	690342	9.2%
	594288	7.9%
o	562088	7.5%
n	522663	7.0%
a	493366	6.6%
i	476783	6.4%
t	397413	5.3%
l	304811	4.1%
b	247907	3.3%
Other values (29)	2516249	33.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5569636	74.2%
Uppercase Letter	957427	12.8%
Space Separator	594288	7.9%
Other Punctuation	380946	5.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	696387	12.5%
e	690342	12.4%
o	562088	10.1%
n	522663	9.4%
a	493366	8.9%
i	476783	8.6%
t	397413	7.1%
l	304811	5.5%
b	247907	4.5%
h	236137	4.2%
Other values (10)	941739	16.9%

Uppercase Letter

Value	Count	Frequency (%)
M	207927	21.7%
F	151938	15.9%
T	115709	12.1%
S	98602	10.3%
B	59852	6.3%
W	59720	6.2%
A	52413	5.5%
H	44006	4.6%
G	41493	4.3%
E	29800	3.1%
Other values (5)	95967	10.0%

Other Punctuation

Value	Count	Frequency (%)
&	221175	58.1%
'	151938	39.9%
\	7833	2.1%

Space Separator

Value	Count	Frequency (%)
	594288	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6527063	87.0%
Common	975234	13.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	696387	10.7%
e	690342	10.6%
o	562088	8.6%
n	522663	8.0%
a	493366	7.6%
i	476783	7.3%
t	397413	6.1%
l	304811	4.7%
b	247907	3.8%
h	236137	3.6%
Other values (25)	1899166	29.1%

Common

Value	Count	Frequency (%)
	594288	60.9%
&	221175	22.7%
'	151938	15.6%
\	7833	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7502297	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	696387	9.3%
e	690342	9.2%
	594288	7.9%
o	562088	7.5%
n	522663	7.0%
a	493366	6.6%
i	476783	6.4%
t	397413	5.3%
l	304811	4.1%
b	247907	3.3%
Other values (29)	2516249	33.5%

discount_amount
Real number (ℝ)

ZEROS

Distinct	28058
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	499.65533

Minimum	-599.5
Maximum	90300
Zeros	376121
Zeros (%)	64.4%
Negative	3
Negative (%)	< 0.1%
Memory size	8.9 MiB

Quantile statistics

Minimum	-599.5
5-th percentile	0
Q1	0
median	0
Q3	160.7344
95-th percentile	2930
Maximum	90300
Range	90899.5
Interquartile range (IQR)	160.7344

Descriptive statistics

Standard deviation	1507.1858
Coefficient of variation (CV)	3.016451
Kurtosis	117.52989
Mean	499.65533
Median Absolute Deviation (MAD)	0
Skewness	6.8412944
Sum	2.919556 × 10⁸
Variance	2271609.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	376121	64.4%
1000	5420	0.9%
2000	4143	0.7%
500	3648	0.6%
200	3495	0.6%
3000	2361	0.4%
7000	2289	0.4%
1500	1625	0.3%
4000	1429	0.2%
2200	1409	0.2%
Other values (28048)	182374	31.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-599.5	1	< 0.1%
-2	2	< 0.1%
0	376121	64.4%
0.08	1	< 0.1%
0.1	6	< 0.1%
0.14	1	< 0.1%
0.15	36	< 0.1%
0.16	1	< 0.1%
0.19	1	< 0.1%
0.2	12	< 0.1%

Value	Count	Frequency (%)
90300	2	< 0.1%
50355.25	5	< 0.1%
50127.75	5	< 0.1%
48205	1	< 0.1%
47500	4	< 0.1%
45000	1	< 0.1%
42498.75	1	< 0.1%
41885	1	< 0.1%
38075.07	8	< 0.1%
35609.39	1	< 0.1%

payment_method
Categorical

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

cod	271770
Payaxis	97640
Easypay	82893
jazzwallet	35145
easypay_voucher	31175
Other values (13)	65691

Length

Max length	17
Median length	16
Mean length	6.1909727
Min length	3

Characters and Unicode

Total characters	3617472
Distinct characters	30
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	cod
2nd row	cod
3rd row	cod
4th row	cod
5th row	cod

Common Values

Value	Count	Frequency (%)
cod	271770	46.5%
Payaxis	97640	16.7%
Easypay	82893	14.2%
jazzwallet	35145	6.0%
easypay_voucher	31175	5.3%
bankalfalah	23057	3.9%
jazzvoucher	15633	2.7%
Easypay_MA	14026	2.4%
customercredit	7554	1.3%
apg	1758	0.3%
Other values (8)	3663	0.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cod	271770	46.5%
payaxis	97640	16.7%
easypay	82893	14.2%
jazzwallet	35145	6.0%
easypay_voucher	31175	5.3%
bankalfalah	23057	3.9%
jazzvoucher	15633	2.7%
easypay_ma	14026	2.4%
customercredit	7554	1.3%
apg	1758	0.3%
Other values (8)	3663	0.6%

Most occurring characters

Value	Count	Frequency (%)
a	635593	17.6%
y	355166	9.8%
c	337170	9.3%
o	327721	9.1%
d	282070	7.8%
s	234812	6.5%
e	132551	3.7%
p	130754	3.6%
l	118024	3.3%
i	107928	3.0%
Other values (20)	955683	26.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3349660	92.6%
Uppercase Letter	222611	6.2%
Connector Punctuation	45201	1.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	635593	19.0%
y	355166	10.6%
c	337170	10.1%
o	327721	9.8%
d	282070	8.4%
s	234812	7.0%
e	132551	4.0%
p	130754	3.9%
l	118024	3.5%
i	107928	3.2%
Other values (15)	687871	20.5%

Uppercase Letter

Value	Count	Frequency (%)
P	97640	43.9%
E	96919	43.5%
M	14026	6.3%
A	14026	6.3%

Connector Punctuation

Value	Count	Frequency (%)
_	45201	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3572271	98.8%
Common	45201	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	635593	17.8%
y	355166	9.9%
c	337170	9.4%
o	327721	9.2%
d	282070	7.9%
s	234812	6.6%
e	132551	3.7%
p	130754	3.7%
l	118024	3.3%
i	107928	3.0%
Other values (19)	910482	25.5%

Common

Value	Count	Frequency (%)
_	45201	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3617472	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	635593	17.6%
y	355166	9.8%
c	337170	9.3%
o	327721	9.1%
d	282070	7.8%
s	234812	6.5%
e	132551	3.7%
p	130754	3.6%
l	118024	3.3%
i	107928	3.0%
Other values (20)	955683	26.4%

BI Status
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

Net	234177
Gross	201317
Valid	148819
#REF!	1

Length

Max length	5
Median length	5
Mean length	4.1984549
Min length	3

Characters and Unicode

Total characters	2453216
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	#REF!
2nd row	Gross
3rd row	Gross
4th row	Net
5th row	Valid

Common Values

Value	Count	Frequency (%)
Net	234177	40.1%
Gross	201317	34.5%
Valid	148819	25.5%
#REF!	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
net	234177	40.1%
gross	201317	34.5%
valid	148819	25.5%
ref	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
s	402634	16.4%
N	234177	9.5%
t	234177	9.5%
e	234177	9.5%
G	201317	8.2%
r	201317	8.2%
o	201317	8.2%
i	148819	6.1%
d	148819	6.1%
a	148819	6.1%
Other values (7)	297643	12.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1868898	76.2%
Uppercase Letter	584316	23.8%
Other Punctuation	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	402634	21.5%
t	234177	12.5%
e	234177	12.5%
r	201317	10.8%
o	201317	10.8%
i	148819	8.0%
d	148819	8.0%
a	148819	8.0%
l	148819	8.0%

Uppercase Letter

Value	Count	Frequency (%)
N	234177	40.1%
G	201317	34.5%
V	148819	25.5%
R	1	< 0.1%
E	1	< 0.1%
F	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
#	1	50.0%
!	1	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2453214	> 99.9%
Common	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	402634	16.4%
N	234177	9.5%
t	234177	9.5%
e	234177	9.5%
G	201317	8.2%
r	201317	8.2%
o	201317	8.2%
i	148819	6.1%
d	148819	6.1%
a	148819	6.1%
Other values (5)	297641	12.1%

Common

Value	Count	Frequency (%)
#	1	50.0%
!	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2453216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	402634	16.4%
N	234177	9.5%
t	234177	9.5%
e	234177	9.5%
G	201317	8.2%
r	201317	8.2%
o	201317	8.2%
i	148819	6.1%
d	148819	6.1%
a	148819	6.1%
Other values (7)	297643	12.1%

MV
Text

Distinct	9720
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

Length

Max length	9
Median length	7
Mean length	4.144573
Min length	1

Characters and Unicode

Total characters	2421732
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2234 ?
Unique (%)	0.4%

Sample

1st row	1,950
2nd row	240
3rd row	2,450
4th row	360
5th row	1,110

Value	Count	Frequency (%)
999	9515	1.6%
699	7801	1.3%
499	7157	1.2%
1,000	6894	1.2%
399	6506	1.1%
299	5997	1.0%
599	5721	1.0%
799	5715	1.0%
2,000	4498	0.8%
899	4353	0.7%
Other values (9710)	520157	89.0%

Most occurring characters

Value	Count	Frequency (%)
0	414270	17.1%
9	399021	16.5%
,	289292	11.9%
1	247183	10.2%
5	220100	9.1%
2	188201	7.8%
4	151871	6.3%
3	146602	6.1%
8	128584	5.3%
6	117159	4.8%
Other values (3)	119449	4.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2121370	87.6%
Other Punctuation	289292	11.9%
Space Separator	8856	0.4%
Dash Punctuation	2214	0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	414270	19.5%
9	399021	18.8%
1	247183	11.7%
5	220100	10.4%
2	188201	8.9%
4	151871	7.2%
3	146602	6.9%
8	128584	6.1%
6	117159	5.5%
7	108379	5.1%

Other Punctuation

Value	Count	Frequency (%)
,	289292	100.0%

Space Separator

Value	Count	Frequency (%)
	8856	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2214	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2421732	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	414270	17.1%
9	399021	16.5%
,	289292	11.9%
1	247183	10.2%
5	220100	9.1%
2	188201	7.8%
4	151871	6.3%
3	146602	6.1%
8	128584	5.3%
6	117159	4.8%
Other values (3)	119449	4.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2421732	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	414270	17.1%
9	399021	16.5%
,	289292	11.9%
1	247183	10.2%
5	220100	9.1%
2	188201	7.8%
4	151871	6.3%
3	146602	6.1%
8	128584	5.3%
6	117159	4.8%
Other values (3)	119449	4.9%

Customer Since
Date

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

Minimum	2016-07-01 00:00:00
Maximum	2018-08-01 00:00:00

Histogram

Histogram with fixed size bins (bins=26)

Customer ID
Real number (ℝ)

HIGH CORRELATION

Distinct	115304
Distinct (%)	19.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45779.112

Minimum	1
Maximum	115326
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 MiB

Quantile statistics

Minimum	1
5-th percentile	546
Q1	13511
median	42850
Q3	73513.75
95-th percentile	107029
Maximum	115326
Range	115325
Interquartile range (IQR)	60002.75

Descriptive statistics

Standard deviation	34411.486
Coefficient of variation (CV)	0.75168531
Kurtosis	-1.125135
Mean	45779.112
Median Absolute Deviation (MAD)	29886
Skewness	0.32681856
Sum	2.6749376 × 10¹⁰
Variance	1.1841504 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85775	2524	0.4%
163	2349	0.4%
35	1877	0.3%
33	1397	0.2%
31025	1369	0.2%
806	1310	0.2%
1404	1269	0.2%
767	1234	0.2%
820	1190	0.2%
58	1182	0.2%
Other values (115294)	568613	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	< 0.1%
3	5	< 0.1%
4	428	0.1%
5	1	< 0.1%
6	2	< 0.1%
7	4	< 0.1%
8	2	< 0.1%
9	1	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
115326	1	< 0.1%
115325	2	< 0.1%
115324	1	< 0.1%
115323	1	< 0.1%
115322	2	< 0.1%
115321	1	< 0.1%
115320	3	< 0.1%
115319	3	< 0.1%
115318	1	< 0.1%
115317	1	< 0.1%

Year
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

2017	290908
2018	159505
2016	133901

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	2337256
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2016
2nd row	2016
3rd row	2016
4th row	2016
5th row	2016

Common Values

Value	Count	Frequency (%)
2017	290908	49.8%
2018	159505	27.3%
2016	133901	22.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2017	290908	49.8%
2018	159505	27.3%
2016	133901	22.9%

Most occurring characters

Value	Count	Frequency (%)
2	584314	25.0%
0	584314	25.0%
1	584314	25.0%
7	290908	12.4%
8	159505	6.8%
6	133901	5.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2337256	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	584314	25.0%
0	584314	25.0%
1	584314	25.0%
7	290908	12.4%
8	159505	6.8%
6	133901	5.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	2337256	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	584314	25.0%
0	584314	25.0%
1	584314	25.0%
7	290908	12.4%
8	159505	6.8%
6	133901	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2337256	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	584314	25.0%
0	584314	25.0%
1	584314	25.0%
7	290908	12.4%
8	159505	6.8%
6	133901	5.7%

Month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.1687261

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	4
median	7
Q3	11
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.4862632
Coefficient of variation (CV)	0.48631559
Kurtosis	-1.3723719
Mean	7.1687261
Median Absolute Deviation (MAD)	4
Skewness	-0.19349323
Sum	4188787
Variance	12.154031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
11	155453	26.6%
5	62571	10.7%
3	61470	10.5%
8	48512	8.3%
7	39146	6.7%
2	38763	6.6%
6	34526	5.9%
4	33985	5.8%
10	30619	5.2%
12	29196	5.0%
Other values (2)	50073	8.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	26050	4.5%
2	38763	6.6%
3	61470	10.5%
4	33985	5.8%
5	62571	10.7%
6	34526	5.9%
7	39146	6.7%
8	48512	8.3%
9	24023	4.1%
10	30619	5.2%

Value	Count	Frequency (%)
12	29196	5.0%
11	155453	26.6%
10	30619	5.2%
9	24023	4.1%
8	48512	8.3%
7	39146	6.7%
6	34526	5.9%
5	62571	10.7%
4	33985	5.8%
3	61470	10.5%

M-Y
Date

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

Minimum	2016-07-01 00:00:00
Maximum	2018-08-01 00:00:00

Histogram

Histogram with fixed size bins (bins=26)

Auto

Heatmap
Table

	item_id	price	qty_ordered	grand_total	discount_amount	Customer ID	Month	status	category_name_1	payment_method	BI Status	Year
item_id	1.000	0.179	0.168	0.294	0.144	0.767	-0.275	0.153	0.194	0.289	0.213	0.927
price	0.179	1.000	-0.162	0.730	0.282	0.221	-0.057	0.028	0.045	0.070	0.039	0.052
qty_ordered	0.168	-0.162	1.000	0.058	-0.049	0.126	-0.158	0.001	0.005	0.007	0.002	0.004
grand_total	0.294	0.730	0.058	1.000	0.247	0.277	-0.113	0.000	0.004	0.012	0.001	0.003
discount_amount	0.144	0.282	-0.049	0.247	1.000	0.099	0.057	0.016	0.047	0.066	0.020	0.009
Customer ID	0.767	0.221	0.126	0.277	0.099	1.000	-0.206	0.105	0.209	0.222	0.154	0.673
Month	-0.275	-0.057	-0.158	-0.113	0.057	-0.206	1.000	0.111	0.168	0.176	0.155	0.486
status	0.153	0.028	0.001	0.000	0.016	0.105	0.111	1.000	0.083	0.154	0.816	0.225
category_name_1	0.194	0.045	0.005	0.004	0.047	0.209	0.168	0.083	1.000	0.135	0.160	0.271
payment_method	0.289	0.070	0.007	0.012	0.066	0.222	0.176	0.154	0.135	1.000	0.331	0.359
BI Status	0.213	0.039	0.002	0.001	0.020	0.154	0.155	0.816	0.160	0.331	1.000	0.180
Year	0.927	0.052	0.004	0.003	0.009	0.673	0.486	0.225	0.271	0.359	0.180	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	item_id	status	created_at	sku	price	qty_ordered	grand_total	category_name_1	discount_amount	payment_method	BI Status	MV	Customer Since	Customer ID	Year	Month	M-Y
0	211131	complete	2016-07-01	kreations_YI 06-L	1950.0	1	1950.0	Women's Fashion	0.0	cod	#REF!	1,950	2016-07-01	1.0	2016	7	2016-07-01
1	211133	canceled	2016-07-01	kcc_Buy 2 Frey Air Freshener & Get 1 Kasual Body Spray Free	240.0	1	240.0	Beauty & Grooming	0.0	cod	Gross	240	2016-07-01	2.0	2016	7	2016-07-01
2	211134	canceled	2016-07-01	Ego_UP0017-999-MR0	2450.0	1	2450.0	Women's Fashion	0.0	cod	Gross	2,450	2016-07-01	3.0	2016	7	2016-07-01
3	211135	complete	2016-07-01	kcc_krone deal	360.0	1	60.0	Beauty & Grooming	300.0	cod	Net	360	2016-07-01	4.0	2016	7	2016-07-01
4	211136	order_refunded	2016-07-01	BK7010400AG	555.0	2	1110.0	Soghaat	0.0	cod	Valid	1,110	2016-07-01	5.0	2016	7	2016-07-01
5	211137	canceled	2016-07-01	UK_Namkino All In One 200 Gms	80.0	1	80.0	Soghaat	0.0	cod	Gross	80	2016-07-01	6.0	2016	7	2016-07-01
6	211138	complete	2016-07-01	kcc_krone deal	360.0	1	60.0	Beauty & Grooming	300.0	cod	Net	360	2016-07-01	7.0	2016	7	2016-07-01
7	211139	complete	2016-07-01	UK_Namkino Mix Nimco 400 Gms	170.0	1	170.0	Soghaat	0.0	cod	Net	170	2016-07-01	6.0	2016	7	2016-07-01
8	211140	canceled	2016-07-01	Apple iPhone 6S 64GB	96499.0	1	96499.0	Mobiles & Tablets	0.0	ublcreditcard	Gross	96,499	2016-07-01	8.0	2016	7	2016-07-01
9	211141	canceled	2016-07-01	Apple iPhone 6S 64GB	96499.0	1	96499.0	Mobiles & Tablets	0.0	mygateway	Gross	96,499	2016-07-01	8.0	2016	7	2016-07-01

	item_id	status	created_at	sku	price	qty_ordered	grand_total	category_name_1	payment_method	BI Status	MV	Customer Since	Customer ID	Year	Month	M-Y
584514	905196	paid	2018-08-28	MEFGUL5A9F882AA5B99-36	1299.0	1	0.0	Men's Fashion	customercredit	Valid	1,299	2018-06-01	111132.0	2018	8	2018-08-01
584515	905198	paid	2018-08-28	MEFPAK5B360B03C6B72	999.0	1	0.0	Men's Fashion	customercredit	Valid	999	2018-06-01	111132.0	2018	8	2018-08-01
584516	905199	pending	2018-08-28	MATINF59BAB39FDBEF1	6760.0	2	13770.0	Mobiles & Tablets	jazzvoucher	Gross	13,520	2016-09-01	8123.0	2018	8	2018-08-01
584517	905200	cod	2018-08-28	WOFVAL59D5EA84167F9-M	400.0	1	550.0	Women's Fashion	cod	Valid	400	2018-08-01	115325.0	2018	8	2018-08-01
584518	905202	cod	2018-08-28	WOFNIG5B4D7EB0E9FDD-L	499.0	1	649.0	Women's Fashion	cod	Valid	499	2018-08-01	115325.0	2018	8	2018-08-01
584519	905204	cod	2018-08-28	WOFSCE5AE00357AECDE	699.0	1	849.0	Women's Fashion	cod	Valid	699	2018-08-01	115320.0	2018	8	2018-08-01
584520	905205	processing	2018-08-28	MATHUA5AF70A7D1E50A	35599.0	1	35899.0	Mobiles & Tablets	bankalfalah	Gross	35,599	2018-08-01	115326.0	2018	8	2018-08-01
584521	905206	processing	2018-08-28	MATSAM5B6D7208C6D30	129999.0	2	652178.0	Mobiles & Tablets	bankalfalah	Gross	259,998	2018-07-01	113474.0	2018	8	2018-08-01
584522	905207	processing	2018-08-28	MATSAM5B1509B4696EA	87300.0	2	652178.0	Mobiles & Tablets	bankalfalah	Gross	174,600	2018-07-01	113474.0	2018	8	2018-08-01
584523	905208	processing	2018-08-28	MATSAM5B10F91A9B6AB	108640.0	2	652178.0	Mobiles & Tablets	bankalfalah	Gross	217,280	2018-07-01	113474.0	2018	8	2018-08-01

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Other Punctuation

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Math Symbol

Control

Dash Punctuation

Space Separator

Open Punctuation

Close Punctuation

Other Symbol

Connector Punctuation

Currency Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category